I am a pragmatic, highly adaptable Oracle database middleware specialist (OCP) who has the ability to work under pressure and in confidence with colleagues, superiors and customers alike .With over 5 years experience, from March, 2013 to present, I am good at analyzing critical issues, challenges and priorities, resolving them in an efficient and resourceful manner through the use of my good communication and experience. I work very successfully without supervision and thrive in challenging environments.
Give Support and Support and Implementation on different Clients like
LESCO
Nishat Chinuin Ltd, Lahore
Peshawar University
Responsibilities:
• Managing backup, performance, etc. of 12 business unit databases of Oracle 11gR2 on Linux 6 64bit
• Technical Support on different versions of EBS R12.2.3 to R12.2.5
• Work on EBS 12.2.2 to 12.2.5 version and DB 10g,11g,12c versions.
• Database & Apps Troubleshooting
• 24/7 & emergency support on site or Remote Support for Production ERP environment.
• Apps and DB’s Backup & Cloning
• Performance and Tuning of Database EBS and SQL Queries.
• Database Security and User Access & Privileges.
• Enterprise Manager configuration and implementing the recommendations.
• Installation of Linux Red Hat and create partitions according to Oracle DB requirements.
• Follow SR recommend patches and solutions
• Recover data through Archive on Cold Backup Cloned.
• Applied web logic patches on EBS 12.2.3 to 12.2.5
• Application Cloning on EBS 12.2.3 to 12.2.5
• Applied Oracle Patches.
• Adop Patching Cycle and OPatch.
Give Full Support to Client like
Oracle EBS R12.2.4 Implementation at LESCO Lahore.
Dealing with Database Corruption and Space issues
Database Troubleshooting
Installing and Upgrading Oracle Database 11g & 12c
Database Security and Access Privileges.
Cold Backup
Oracle Patches
Apps and DB Cloning
RMAN Cold and Hot Backup
BMP SOA server administration
Performance and Tuning of database.
Flashback Recovery and Data Pump
Create remotely access to Server Pc through SSH, VNC, Winscp & Telnet
Installation of Linux Red Hat and create partitions according to Oracle DB requirements.
Oracle EBS R12.2.5 Implementation at University of Peshawar
Dealing with Database Corruption and Space issues
Database Troubleshooting
RMAN Backup and Recovery
Performance and tuning of database and application
Patching
Cloning
Technic
Working in BiFringence as ERP Technical Consultant from Sep, 2015 having following responsibilities:
• Oracle EBS R12 Implementation at NADRA Head Quarter Islamabad.
• Software/Hardware Requirement: Capacity planning for hardware and software in the configuration and implementation of Oracle Application R12.
• Advised management on long-term strategy, planning, and implementation of new releases of Oracle and related System Software.
• Estimating Database size growth (Database Size Management).
• Estimating File System Growth (Physical Space Management).
• Estimating OS requirement to handle all Application components.
• Installation/Upgrading and Cloning:
• Installation Oracle Linux 7
• Installation Oracle Application R12 using Rapid wiz in multi-node architecture.
• Build Multiple Test Instance using Oracle Application Cloning Process.
• Cloning Oracle application/Database using ADCLONE and Rapid
• Up-grad Oracle Application to latest patch level using Maintenance Patch (e.g12.0.2.0 - 12.0.2.3).
• Installing Developer 10g, Workflow Builder and other Development tools on Developer machines.
• Backups and Disaster Recovery: Implementing Comprehensive Backup/Restore mechanism and data replication.
• Configuration of Recovery Manager (RMAN) for Online Backup on SAN Storage
• Configuration of incremental Backup on SAN Storage
• Backup and Recovery through Tar
• Optimization/Performance Tuning: Performance tuning & monitoring of the Oracle Application, Database and Unix kernel parameters
• Database Space Management and Pinning Objects
• Analyzing Schema (Gather Schema Statistics)
• Troubleshooting Oracle Application Performance/Tuning Issues.
• Regular Maintenance Activities:
• Performed activities such as Security Management, Space Management, User and Responsibility set-up, Performance Tuning & Monitoring, Concurrent Manager Monitor, defining printers, and setup Oracle Alerts/Auditing.
• Managing Oracle Applications Security
Worked in Wizmen System Lahore. (March , 2013 to Sep2015)
• Installations, configuration and maintenance of database and security implementation on multiple platforms.
• Working environment (Oracle 10g, 11g in windows) and can manage databases in Linux and UNIX environment.
• Having knowledge of Oracle database backup and recovery and create script for backup
and recovery.
• Data Migration using data pump, export and import utility.
• Provided Oracle database administrative support to different clients.
• Migration and up gradation of databases from 10g to 11g. .
• Oracle Data guard (10g) configuration on Linux operating system and windows.
• Implementation of database auditing OS /Database level.
• Perform backup, recovery using RMAN, Data Pump.
• Documentation of oracle databases.
Client Exposure at Wizmen Systems
• South Asian Partners (NGO in more than 18 Districts across the country).
• Lahore American School.
• PRDL (Real Estate). (Lahore)s
• Divine Developers (Real Estate) (Lahore).
• Zaitoon Group (New Lahore City)
• Din Group (textile)
• Triumphant international (Yum Chinese, Spice Bazar)
• Gulistan Group (textile)
• Ijaz Group (textile)
• Amjad Group (textile)